<?php
    class Menu extends CI_Model{
        function __construct(){
            // Call the Model constructor
            parent::__construct();
        }

        public function getList(){        
            $sql = "SELECT * FROM menus 
                JOIN controllers ON controllers.controller_id = menus.controller_id
                JOIN actions ON actions.action_id = menus.action_id
                JOIN action_types ON action_types.action_type_id = actions.action_type_id";
            $query = $this->db->query($sql, 200);
            return $query->result();
        }
        
    }  
?>